---
title: SAIF.Business.Policy SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Claims BOF team
last_reviewed: 2026-08-21
library: SAIF.Business.Policy
reference_type: embedded
---

# SAIF.Business.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type. All statements found are read-only — this library owns no `INSERT`/`UPDATE`/`DELETE` SQL.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-benefit-jurisdiction-code-lookup.md) | Retrieve benefit-jurisdiction code/description list | Inline | [BENEFIT_JURISDICTION_CODE](../database-tables.md#benefit_jurisdiction_code) | `clsBenefitJurisdictionCodeMap` |
| [SQL-002](SQL-002-hazard-group-retrieve.md) | Retrieve hazard groups effective on a date | Inline (StringBuilder-assembled) | [HAZARD_GROUP](../database-tables.md#hazard_group) | `clsHazardGroupCollection` |
| [SQL-003](SQL-003-manual-class-type-code-lookup.md) | Retrieve manual-class-type code/description list | Inline | [MANUAL_CLASS_TYPE_CODE](../database-tables.md#manual_class_type_code) | `clsManualClassTypeCodeMap` |
| [SQL-004](SQL-004-policy-period-anniversary-rate-date.md) | Retrieve anniversary rate date for a policy period | Inline | [POLICY_PERIOD](../database-tables.md#policy_period), [POLICY_PERIOD_NON_WCIS](../database-tables.md#policy_period_non_wcis) | `PolicyInformation` |
| [SQL-005](SQL-005-policy-market-type-lookup.md) | Retrieve market type code for a policy | Inline | [POLICY](../database-tables.md#policy) | `PolicyInformation` |
| [SQL-006](SQL-006-policy-ownership-system-lookup.md) | Determine whether WCIS owns a policy submission | Inline (PL/SQL function via DUAL) | N/A (PL/SQL function) | `PolicyInformation` |
| [SQL-007](SQL-007-information-page-printed-check.md) | Check whether the information page was printed | Inline | [ENDORSEMENT](../database-tables.md#endorsement) | `PolicyInformation` |
| [SQL-008](SQL-008-max-policy-effective-date.md) | Retrieve maximum policy effective date | Inline | [POLICY_PERIOD](../database-tables.md#policy_period) | `PolicyInformation` |
| [SQL-009](SQL-009-max-premium-history-set-id.md) | Retrieve maximum premium-history set ID | Inline | [PREM_HIST_SUMMARY](../database-tables.md#prem_hist_summary) | `PolicyInformation` |
| [SQL-010](SQL-010-policy-minimum-premium-procedure.md) | Retrieve minimum premium and expense constant | Stored Proc | N/A (stored procedure) | `PolicyInformation` |
| [SQL-011](SQL-011-policy-period-expiration-date.md) | Retrieve policy-period expiration date | Inline | [POLICY_PERIOD](../database-tables.md#policy_period), [POLICY_PERIOD_NON_WCIS](../database-tables.md#policy_period_non_wcis) | `PolicyInformation` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `SAIF.Business.Policy\clsHazardGroupCollection.vb`
- `SAIF.Business.Policy\PolicyInformation.vb`
- `SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb`
- `SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb`